home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 1998 January / Macworld (1998-01).dmg / FileMaker Pro 4 / Full FM4 Templates / Education / Loans (.txt) < prev    next >
FileMaker Pro Database  |  1997-09-14  |  98KB  |  648 lines
  1. HBAM2016AUG95
  2. Pro 3.0
  3. HBAM3016AUG95
  4. Pro 2.0 - 2.1F!
  5. Pro 3.0
  6. CHECK OUT PER
  7. CREATED BY
  8. DATE CHECK IN
  9. DATE CHECK OUT
  10. DATE DUE
  11. DATE MODIFIED
  12. DEP AMOUNT
  13. DEP REFUNDED
  14. FIRST NAME
  15. ITEM DESCRIPTION
  16. ITEM ID
  17. C    ITEM TYPE
  18. :    LAST NAME
  19. OVERDUE CALC
  20. I    RECORD ID
  21. STUDENT ID
  22. A    Record IDB
  23. NameB
  24. Date ModifiedB
  25. Date Check OutB
  26. :A    Item TypeB
  27. Date DueB
  28. N - 1
  29. BA    Last NameB
  30. Item IDB
  31. Dep AmountB
  32. Dep RefundedB
  33. Date Check InB
  34. Item DescriptionB
  35. Student IDB
  36. Sunday
  37. Monday
  38. Tuesday
  39.     Wednesday
  40. Thursday
  41. Friday
  42. Saturday
  43. January
  44. February
  45. March
  46. April
  47. August
  48.     September
  49. October
  50. November
  51. December
  52. 1st Quarter
  53. 2nd Quarter
  54. 3rd Quarter
  55. 4th Quarter
  56. 11/20/95
  57. A    Form View
  58. A    List View
  59. Overdue Items
  60. Information
  61. Report Menu
  62. A    Form ViewB
  63. Yesfter
  64. Noarter
  65. Yesfter
  66. Noarter
  67. Yesfter
  68. Noarter
  69. Yesfter
  70. Noarter
  71. Overdue CalcB
  72. = > 0
  73.  "Overdue"
  74.  "")))
  75. Overdue
  76. InfoB
  77. Check Out PerB
  78. Created ByB
  79. Description
  80. Use this database to maintain information on items that have been loaned, such as software, CDs, books, sporting equipment, and musical instruments. 
  81. How to use this solution
  82. You can add your school logo to the Overdue Items report and print an outstanding loan list.
  83. How to customize this solution
  84. You can use a relation to the Students file based on the Borrower ID field to display the First Name and Last Name, eliminating the need for duplicate data entry.
  85. A    List ViewB
  86. Yesfter
  87. Noarter
  88. Yesfter
  89. Noarter
  90. Yesfter
  91. Noarter
  92. Yesfter
  93. Noarter
  94. Yesfter
  95. Noarter
  96. Yesfter
  97. Noarter
  98. Yesfter
  99. Noarter
  100. Yesfter
  101. Noarter
  102. Yesfter
  103. Noarter
  104. Yesfter
  105. Noarter
  106. Yesfter
  107. Noarter
  108. Yesfter
  109. Noarter
  110. Yesfter
  111. Noarter
  112. Yesfter
  113. Noarter
  114. Deposit
  115. Check In
  116. Amount
  117. Overdue?
  118.     Check Out
  119. Date Due
  120. Description
  121. Borrower
  122.     Last Name
  123. First Name
  124. Enter data for Loaned Items
  125. Close
  126. View As
  127. View As
  128. Reports
  129. Record
  130. Delete
  131. Record
  132. Record
  133. Your Own
  134. Button
  135. Your Own
  136. Button
  137. Loaned Items
  138. Overdue ItemsB
  139. Yesfter
  140. Noarter
  141. Yesfter
  142. Noarter
  143. Yesfter
  144. Noarter
  145. Yesfter
  146. Noarter
  147. Yesfter
  148. Noarter
  149. Yesfter
  150. Noarter
  151. Yesfter
  152. Noarter
  153. Out[    Last Name\
  154. First Name]
  155. Description^
  156. Item ID_
  157. IDj/Click to see more information for a Loaned Itemk
  158. Infol
  159. Closem
  160. View As
  161. Formn
  162. View As
  163. Listo
  164. Reportsp
  165. Recordq
  166. Delete
  167. Recordr
  168. Records
  169. Your Own
  170. Buttont
  171. Your Own
  172. Button
  173. InformationB
  174. Yesfter
  175. Noarter
  176. Yesfter
  177. Noarter
  178. Yesfter
  179. Noarter
  180. Yesfter
  181. Noarter
  182. Date Due
  183. Date Out
  184. O    Last Name
  185. First Name
  186. Description
  187. Item ID
  188. S    Record ID
  189. Page ##
  190. Overdue Items
  191. Close
  192. View As
  193. View As
  194. Reports
  195. Your Own
  196. Button
  197. Report MenuB
  198. P$Information about the Loans databaseQ
  199. Info for this SolutionR
  200. InfoS
  201. CloseT
  202. View As
  203. FormU
  204. View As
  205. ListV
  206. ReportsW
  207. Your Own
  208. Button
  209. Your Own
  210. ReportB
  211. Your Own
  212. ReportC
  213. Your Own
  214. ReportD
  215. Overdue
  216. ItemsL>Click on any of these buttons to preview the respective reportM
  217. Select a reportN
  218. InfoO
  219. CloseP
  220. View As
  221. FormQ
  222. View As
  223. ListR
  224. ReportsS
  225. Your Own
  226. Button
  227. erdue Items
  228. Open Script
  229. Sort by Last Name
  230. Overdue Items
  231. Sort by Record ID
  232. Sort by Item ID
  233. Sort by Item Description
  234. Sort by Date Checked Out
  235. InfoT
  236. CloseU
  237. View As
  238. FormV
  239. View As
  240. ListW
  241. ReportsX
  242. Your Own
  243. Button
  244. wwwwww
  245.     ffffff
  246. UUUUUU
  247. DDDDDD
  248. 3333B
  249. """"""
  250. #11#22122"3!
  251. "#""3"129
  252. C3C3C34C4C3CC43C
  253. DDCD4DD4CDDC
  254. 4CDD4E4ET
  255. TEETEETUETUETUDUDEETUDTUE[
  256. Sort by Date Checked In
  257. Open Script
  258. )=400    
  259. Cancel
  260. You did not enter any find criteria; all records will be displayed.C+
  261. ) = 0    
  262. Cancel
  263. No records match this request.E+
  264. ) = 1    
  265. Sort by Record ID
  266. Sort by Item ID
  267. Sort by Item Description
  268. Sort by Last Name
  269. Sort by Date Checked Out
  270. Sort by Date Checked In
  271. Overdue Items
  272. Open Script
  273. Sort by Last Name
  274. Overdue Items
  275. Sort by Record ID
  276. Sort by Item ID
  277. Sort by Item Description
  278. Sort by Date Checked Out
  279. wwwwww
  280.     ffffff
  281. UUUUUU
  282. DDDDDD
  283. 3333B
  284. """"""
  285. wwxwwxw
  286. ggvgvv
  287. gvwxgwghg
  288. vhgvvww
  289. fvfgfwffv
  290. eVefefe
  291. VvffVefVVefUe\
  292. ffFdeefeefddfDeVdfEdfFdffk
  293. EUeFFEUFEUFFUeTeVFeUUdVEEk
  294. UTdUTeETeETeEUFTUTUFTUUTeK
  295. TEETEETUETUETUDUDEETUDTUE[
  296. 4CDD4E4ET
  297. D4DD4CDDC
  298. C3C3C34C4C3CC43C
  299. "#""3"129
  300. #11#22122"3!
  301. dUTeETeETeEUFTUTUFTUUTeK
  302. EUeFFEUFEUFFUeTeVFeUUdVEEk
  303. ffFdeefeefddfDeVdfEdfFdffk
  304. eVefefe
  305. VvffVefVVefUe\
  306. fvfgfwffv
  307. ggvgvv
  308. gvwxgwghg
  309. vhgvvww
  310. Ejwwg
  311. wwxwwxw
  312. (LIST
  313. LISTAPAudio CD
  314. Audio Tape
  315. Musical Instrument
  316. Software
  317. Sports Equipment
  318. Video Tape
  319. VDEFA(
  320. (LIST
  321. LISTA
  322. Refunded
  323. VDEFA(
  324. Item Type ListB
  325. Deposit Refunded List
  326. ~ffff
  327. ffffff
  328. ffff33
  329. ff33ff
  330. ff3333
  331. 33ffff
  332. 33ff33
  333. 3333ff
  334. 333333
  335. wwwwww
  336. UUUUUU
  337. DDDDDD
  338. """"""
  339. wwwwww
  340.     ffffff
  341. UUUUUU
  342. DDDDDD
  343. 333333
  344. wwwwww
  345.     ffffff
  346. UUUUUU
  347. DDDDDD
  348. 333333
  349. wwffeffg@
  350. veUEDDCC
  351. vUTDD44
  352. vUDDC32
  353. #""# 
  354. weUDD3
  355. veTDC2233#3#2
  356. wUDDC3##"
  357. vUTD3#22
  358. vUDDC
  359. fUD42233##3#"!
  360. vTDCC##"
  361. eUDC3223##
  362. fTD4C3##23#""
  363. uTDC3323#2""!
  364. 22"2"
  365. ##2"!
  366. fTDD33#22""
  367. vUDC32"2""
  368. WUTC22
  369. eTD3#""
  370. GDC32"!!
  371. eD3#"!
  372. T32""
  373. "%UR 
  374. UD33D 
  375. #4EWp
  376. "4EVx
  377. #3EVg
  378. "4DUg
  379. #3EVg
  380. "#4DVg
  381. 24EVgy
  382. "34EVw
  383. ##4Efw
  384. ""3DUgw
  385. ""33DUfw
  386. ""34DVgx
  387. ""#34EVgx
  388. "#33DEfw
  389. "    234DUfw
  390. 2""2334DEVgx
  391. 3    4DEUfwx
  392. 3    DDUVgw
  393. D    EUUfwx
  394. UDDEUUfgw
  395. U    Vfgwx
  396. eUVfgww
  397. B"#B@
  398. B"#B"$
  399. 4"2$B"#B"#C
  400. 2$""#B"#C0
  401. 4"2#B"#C0
  402. 2$B"#C0
  403. 4""#C0
  404. AD@D@
  405. AD@D@
  406. AD@BL
  407. 44444
  408. CCCCC 44444 CCCCC 
  409. $42" 
  410. @@BA@
  411. bRBBP0
  412. UUUUUU
  413. wwwwww
  414. (*)(%,3&    
  415. )%+@6) 
  416. ",30,)%
  417.  #*>A6332+$"!
  418. 25,878
  419. #&$690*"
  420. !)0,++)(
  421.  "%/66435/'#
  422. +3;4*=
  423. !#,@9,)+,(""(-/,,*
  424. !$&(265389,#!$$
  425. '275?
  426. " $$*23/$
  427. $),-..)''
  428. !$&)(-5439@1!!&*-3/)!!%6B)
  429. )220(!$*.,,.' 
  430. !$&*,*023:?B+*.,/3254.'
  431. "++,3/(.584.,"
  432. !#&+/-./3:9@G@60/16883)!
  433. $++//'(9CD>4.$$
  434. $%)*-//2693,.075-&)3792,$
  435. ")-1347<>@G71(!
  436. **)&'*.0350+%(=A2'%)579<94(
  437. +/11!
  438. !%'),342)1?=0)"
  439. .1,$',-01)*).AG6-/048:<
  440. /2583$%+66/%
  441.  %)++*),+&%06,%$#
  442. !/40')-/31$$,@HFC<6887:==@B7%!
  443. 6A235,% 
  444. +,/13.%#"(16+
  445. !#$(04-$&+,+$
  446. %2>D6,59:989889=0
  447. ,.22<=33*
  448. .22671#
  449. !!&/42&
  450. *1$&+,/3779733,
  451.  $$PQ
  452. /004B6*
  453. !$$ $))'/3)
  454. %&$&.7;4
  455. )2$)*3-)466/%$
  456. !),02+'
  457. %$5)%*+%$!
  458. (+'0:==4
  459. $+,,1643"%)"
  460. !)/1)*+
  461. +7=-%%&$!
  462. !3)3=.
  463. %&*/3113
  464.  !$$PQ
  465. ',4-%)/)
  466. ,6/%$$" 
  467. +(!<-
  468. %),0354-
  469. .13-&,-*
  470. 14'$$! 
  471. %))&%$!
  472. '3*$$" 
  473. !&$%3
  474. &%"%&
  475. 9836'
  476. )&#%%!
  477. $*)++"
  478. .-/:%
  479. !"&)()15,
  480. )" /.-+)!
  481. //6B&
  482.  #'*,.42$
  483. $/,-*%
  484. IF1A1
  485. "%.2/-*#!
  486. $/.,*($!#$"%PQ
  487. #57-*'$#"$&'
  488. ..//.-,)'(.212PQ
  489. ",,)&%'.;<6/+',,)%!
  490. '//,+//*)+.4:=>PQ
  491. $(&(),5?@:2/,,''*$
  492. -!,,%.0%)./7
  493. #43((+9CA=3+,)+"
  494. &*)2!$96;;48@??PQ
  495. )/01%$
  496. #3/').:@<3)$&)!
  497. /)4$%)8=A@?><@PQ
  498. !.0/.+//./1//*
  499. *.').3784/%
  500. ,,#%()25:<99=PQ
  501. %10//
  502. 0 /+134,.25653."
  503. )++-!
  504. # %0,*,384'%PQ
  505. 42//11/&(/563135650(
  506. (./36$
  507. !"23.,27- 
  508. 6:=<)&931-13-!$.69433563+
  509. ,/258 #$,96-37)$!PQ
  510. 38;?B>;63/.22.-068934673(
  511. ,638<6$
  512. *),/6."')==138*$)PQ
  513. 35:=@B>953-/1.-368<:8995&
  514. %668:9(
  515. )$'*.:&$*==8/,
  516. -19=@CA>:83+2.,0157:
  517. !""/88$
  518. !)*# 6/0%&' !$*38,.<;60"
  519. +07=@CD=6>@.*)&(*-03;@@<-
  520. 6.3/%
  521. #/23989=2,*%
  522. /039>B@ "9E7,)+/3667:?CE/!"
  523. $$%199207/
  524. 9K8@)
  525. 3933"
  526. !0042381%$(.-)56PQ
  527. 556:=@@
  528. 5C958=BGGA96;='"+-
  529. !!%.94.6BDCFM='(204967&
  530. //2346%
  531. $59232$PQ
  532. :9<@?@C% 6D;;CJLONG952
  533. (9304=FCDDE>%
  534. $,585'
  535. !.//11'$/;81$
  536. 9:CE><D3,5G@@HF>IF94)
  537. $#%+*159C=:>FG)
  538. *31*#
  539. $/51#
  540. 89C=.!:9=C<9AFGCA7&(
  541. /%3%!'+5A<6=C>$
  542. -672.3<<961.%!
  543. ,,%=<9/69/02. 
  544. "773//33/,+)
  545. /1$'9<
  546. 069850(*)'%
  547. %/+$ 
  548. !&##34
  549. %0<PQ
  550. %"$:C9.*$
  551. !+6@PQ
  552. "$$6CD>>5
  553. !##()
  554. ".;CPQ
  555.  %'0>GFA:378+&&%$$,&
  556. ,:CPQ
  557. $(,027CGG@6681//,)%$/
  558. '7CPQ
  559. !%*/1,/44CC;6547@=2*!%.$
  560. %;CPQ
  561. '$)=3
  562.  #%)*())3DLHB
  563. ?MB9/% !
  564. "'6?6$
  565. *;=PQ
  566. $%&,9D6
  567. !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
  568. !)/38;@(
  569. "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
  570. +/0,$%&%%,26:5)
  571. "$%&(/7;<=BGIJIGMG=953'%(1<<63/!
  572. $*.8PQ
  573. 876=@?<3),3:8$
  574. !&((),3=;::=EHIC:<F3)'""#&+/,',
  575. #&(0PQ
  576. FC8:CF@7/08<(
  577. "'()*,
  578. 169?:6=C=2..3'"
  579. "%&)PQ
  580. HD99=A@9534/
  581. !26(%5, 
  582. ! !),''*-16<@=430/,+/)!
  583. ??979>@@:-!
  584. !$+%-*),/37<@:2/-*)+*" 
  585. 4?=95;@@9&
  586. *#%.,/136884/,)'),,%)+(%$$
  587. />C:13?@9)$ 
  588. !!89+
  589. !)$%*-/13321/,*3*)-/0/+&$$!
  590.  6A:0,8B=1+)/68.%/(,9=2%
  591. ")$"%)-02331/31)/().241+%##!
  592. *79/)/:<651/33)2<8.6=9. 
  593. !$%,56643/75,'&).340+&#!$$%#!
  594. .5.)/46682%#$$-973:=<7)
  595. !$'+4:964063+(
  596. ,33/+(&'),*)'#
  597. "%%.2379:1&"%(&.36@?@D5 
  598. !$%')/8:86>=2)&!!-231
  599. 34772+*
  600.  &46339C@4+,3/)/:<D/8J='
  601. "%'))+336@3(/)%#%,34569<=?CE5,)!
  602.  #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
  603. #,0258<?ADGE2 "'(#
  604. "%),,/6983$
  605. &4<9+4DD>?J>/*-6;<6,,/25.))3,'
  606. ",.0369;=AGE.
  607. !%%(,.040'
  608. 2A?EA4*+/683*.493/($!/-,
  609. 0246689:AC7%
  610. $%##(.23&
  611. :96,#"%)*(%(364,
  612. M4%"!!"560&)/<9;989;>3$
  613. "03., PQ
  614. UUUUUU
  615. wwwwww
  616.     Helvetica
  617. Geneva
  618. Times
  619. Times New Roman
  620. Arial
  621. MS Sans Serif
  622. Terminal
  623. wwwwww
  624.     ffffff
  625. UUUUUU
  626. DDDDDD
  627. 3333B
  628. """"""
  629. #11#22122"3!
  630. "#""3"129
  631. C3C3C34C4C3CC43C
  632. DDCD4DD4CDDC
  633. 4CDD4E4ET
  634. TEETEETUETUETUDUDEETUDTUE[
  635. First NameB
  636. Date ModifiedB
  637. Date Check OutB
  638. :A    Item TypeB
  639. Date DueB
  640. N - 1
  641. BA    Last NameB
  642. Item IDB
  643. Dep AmountB
  644. Dep RefundedB
  645. Date Check InB
  646. Item DescriptionB
  647. Student IDB
  648.